package com.pointi.emoTools;

public class bdPreProcess
{
	private int callkey ;
	private int subtime ;
	private double anger ;
	private double neutral ;
	private double energy ;
	private int anger_cnt ;
	private int neutral_cnt ;
	private int section ;
	private int overlap ;
	
	public bdPreProcess()
	{
		//
	}
	
	public bdPreProcess(int callkey, int subtime, double anger, double neutral, double energy, int anger_cnt, int neutral_cnt, int section, int overlap)
	{
		this.callkey = callkey ;
		this.subtime = subtime ;
		this.anger = anger ;
		this.neutral = neutral ;
		this.energy = energy ;
		this.anger_cnt = anger_cnt ;
		this.neutral_cnt = neutral_cnt ;
		this.section = section ;
		this.overlap = overlap ;
	}
	
	public void callkey(int callkey) { this.callkey = callkey ; }
	public void subtime(int subtime) { this.subtime = subtime ; }
	public void anger(double anger) { this.anger = anger ; }
	public void neutral(double neutral) { this.neutral = neutral ; }
	public void energy(double energy) { this.energy = energy ; }
	public void anger_cnt(int anger_cnt) { this.anger_cnt = anger_cnt ; }
	public void neutral_cnt(int neutral_cnt) { this.neutral_cnt = neutral_cnt ; }
	public void section(int section) { this.section = section ; }
	public void overlap(int overlap) { this.overlap = overlap ; }
	
	public int callkey() { return callkey ; }
	public int subtime() { return subtime ; }
	public double anger() { return anger ; }
	public double neutral() { return neutral ; }
	public double energy() { return energy ; }
	public int anger_cnt() { return anger_cnt ; }
	public int neutral_cnt() { return neutral_cnt ; }
	public int section() { return section ; }
	public int overlap() { return overlap ; }
	
	public String fnGetQuery(String inDate)
	{
		String query = "" ;
		query = "INSERT INTO t_engine_Y" + inDate + " (" +
				" callkey , " +
				" subtime , " +
				" anger , " +
				" neutral , " +
				" energy , " +
				" anger_cnt , " +
				" neutral_cnt , " +
				" section , " +
				" overlap " +
				") VALUES (" +
				callkey + ", " + 
				subtime + ", " + 
				anger + ", " + 
				neutral + ", " + 
				energy + ", " + 
				anger_cnt + ", " + 
				neutral_cnt + ", " + 
				section + ", " + 
				overlap + 
				") ;" ;
		return query ;
	}
}
